#! /usr/bin/env python
# -*- coding: utf-8 -*-

company_name = '福建优力特材料有限公司'
risk_obj_name = '产品验证对象'
responsible_dept_id = '1902911168420225025'
is_major_hazard = 1
create_dept = '1820379858379681793'



query_sql = '''
SELECT
    count(*) 
FROM
    hgyq_emergency.rp_m_risk_analysis_object
WHERE
    is_deleted = 0 
    AND create_dept = "''' + create_dept + '''" 
    AND is_major_hazard = "''' + str(is_major_hazard) + '''"
    AND risk_obj_name = "''' + risk_obj_name + '''" 
    AND responsible_dept_id = "''' + responsible_dept_id + '''"
'''